package net.dgg.zz.production.statistics.vo;

import net.dgg.zz.common.utils.excel.Excel;

/**
 * <p>@Title 办理中导出VO</p>
 * <p>@Description 办理中相关</p>
 * <p>@Version 1.0.0 版本号</p>
 * <p>@author maoquanyi</p>
 * <p>@date 2018年08月13日</p>
 * <p>Copyright © dgg group.All Rights Reserved. 版权信息</p>
 */
public class OrderDetailVo {

    /**
     * 生产订单
     *
     * select o.id as id, o.sc_product_order_no as scProductOrderNo ,o.order_no as orderNo,o.receive_time as receiveTime,o.receiver_org_name as receiverOrgName,o.customer_name as
     * customerName,o.customer_phone as customerPhone,o.business_product_code as businessProductCode,o.business_product_name as businessProductName,zp.product_attr as productAttr,o.product_name as productName,o.contract_end_date as contractEndDate,zp.contract_no as contractNo, o.`status` as `status`,o.latest_end_node_id as latestEndNodeId,o.latest_end_node_name as latestEndNodeName,o.current_node_name as currentNodeName,o.flow_type as flowType,o.flow_user_id as flowUserId,o.flow_user_name as flowUserName,o.product_user_id as productUserId,o.product_user_name as productUserName,o.sign_user_id as signUserId,o.sign_user_name as signUserName,
     *     case when DATEDIFF(now(),o.contract_end_date)<![CDATA[<]]>0 then concat('剩余',-1*DATEDIFF(now(),o.contract_end_date),'天') else concat('超期',DATEDIFF(now(),o.contract_end_date),'天') end contractStr, node.nodeStr,ord.orderStr,ot.overStr,p.publicityNotPassNum,n.noticeNotPassNum,d.deliveryNum,zp.money,case when o.`status`='ZZSC_STATE_SCPROORDER_CODE15' then update_time else '' end nodeTermTime, ds.deliveryStr,ps.publicityStr,pn.publicityNum,pn.noticeNum,cs.certificationStr,es.endStr,p.personalName
     *
     *
     */
    @Excel(column = 0, name = "生产订单编号")
    private String scProductOrderNo;

    /**
     * 销售订单
     */
    @Excel(column = 1, name = "销售订单")
    private String orderNo;

    /**
     * 接单时间
     */
    @Excel(column = 2, name = "接单时间")
    private String receiveTime;

    /**
     * 客户名称
     */
    @Excel(column = 3, name = "客户名称")
    private String customerName;

    /**
     * 企业名称
     */
    @Excel(column = 4, name = "企业名称")
    private String companyName;

    /**
     * 业务类型
     */
    @Excel(column = 5, name = "业务类型")
    private String businessProductName;

    /**
     * 产品名称
     */
    @Excel(column = 6, name = "产品名称")
    private String productName;

    /**
     * 产品属性
     */
    @Excel(column = 7, name = "产品属性")
    private String productAttr;

    /**
     * 合同编号
     */
    @Excel(column = 8, name = "合同编号")
    private String contractNo;
    /**
     * 合同周期
     */
    @Excel(column = 9, name = "合同周期")
    private String contractCycle;
    /**
     * 到期时间
     */
    @Excel(column = 10, name = "到期时间")
    private String contractEndDate;

    /**
     * 合同金额
     */
    @Excel(column = 11, name = "合同金额")
    private String money;

    /**
     * 订单状态
     */
    @Excel(column = 12, name = "订单状态")
    private String status;

    /**
     * 当前完成节点
     */
    @Excel(column = 13, name = "当前完成节点")
    private String latestEndNodeName;


    /**
     * 项目类型
     */
    @Excel(column = 14, name = "项目类型")
    private String flowType;

    /**
     * 当前流程人员
     */
    @Excel(column = 15, name = "当前流程人员")
    private String flowUserName;

    /**
     * 生产负责人
     */
    @Excel(column = 16, name = "生产负责人")
    private String productUserName;
    /**
     * 签单商务
     */
    @Excel(column = 17, name = "签单商务")
    private String signUserName;
    /**
     * 签单时间
     */
    @Excel(column = 18, name = "签单时间")
    private String signTime;
    /**
     * 签单商务部门
     */
    @Excel(column = 19, name = "签单商务部门")
    private String signUserOrgName;
    /**
     * 交件次数
     */
    @Excel(column = 20, name = "交件次数")
    private String deliveryNum;
    /**
     * 交件记录
     */
    @Excel(column = 21, name = "交件记录")
    private String deliveryStr;
    /**
     * 公示次数
     */
    @Excel(column = 22, name = "公示次数")
    private String publicityNum;
    /**
     * 公示次数
     */
    @Excel(column = 23, name = "公示记录")
    private String publicityStr;
    /**
     * 公示号
     */
    @Excel(column = 24, name = "公示号")
    private String publicityNo;
    /**
     * 通告次数
     */
    @Excel(column = 25, name = "通告次数")
    private String noticeNum;
    /**
     * 通告记录
     */
    @Excel(column = 26, name = "通告记录")
    private String noticeStr;
    /**
     * 通告号
     */
    @Excel(column = 27, name = "通告号")
    private String noticeNo;
    /**
     * 领证记录
     */
    @Excel(column = 28, name = "领证记录")
    private String certificationStr;

    /**
     * 完结记录
     */
    @Excel(column = 29, name = "完结记录")
    private String endStr;

    /**
     * 结项时间
     */
    @Excel(column = 30, name = "结项时间")
    private String nodeTermTime;

    /**
     * 使用证书
     */
    @Excel(column = 31, name = "使用证书")
    private String personalName;

    /**
     * 当前节点超期时长
     */
    @Excel(column = 32, name = "当前节点超期时长")
    private String nodeStr;
    /**
     * 订单超期时长
     */
    @Excel(column = 33, name = "订单超期时长")
    private String orderStr;
    /**
     * 合同超期时长
     */
    @Excel(column = 34, name = "合同超期时长")
    private String contractStr;
    /**
     * 合同超期时长
     */
    @Excel(column = 35, name = "节点超期记录")
    private String overStr;

    public String getScProductOrderNo() {
        return scProductOrderNo;
    }

    public void setScProductOrderNo(String scProductOrderNo) {
        this.scProductOrderNo = scProductOrderNo;
    }

    public String getOrderNo() {
        return orderNo;
    }

    public void setOrderNo(String orderNo) {
        this.orderNo = orderNo;
    }

    public String getReceiveTime() {
        return receiveTime;
    }

    public void setReceiveTime(String receiveTime) {
        this.receiveTime = receiveTime;
    }

    public String getCustomerName() {
        return customerName;
    }

    public void setCustomerName(String customerName) {
        this.customerName = customerName;
    }

    public String getCompanyName() {
        return companyName;
    }

    public void setCompanyName(String companyName) {
        this.companyName = companyName;
    }

    public String getBusinessProductName() {
        return businessProductName;
    }

    public void setBusinessProductName(String businessProductName) {
        this.businessProductName = businessProductName;
    }

    public String getProductName() {
        return productName;
    }

    public void setProductName(String productName) {
        this.productName = productName;
    }

    public String getProductAttr() {
        return productAttr;
    }

    public void setProductAttr(String productAttr) {
        this.productAttr = productAttr;
    }

    public String getContractNo() {
        return contractNo;
    }

    public void setContractNo(String contractNo) {
        this.contractNo = contractNo;
    }

    public String getContractCycle() {
        return contractCycle;
    }

    public void setContractCycle(String contractCycle) {
        this.contractCycle = contractCycle;
    }

    public String getContractEndDate() {
        return contractEndDate;
    }

    public void setContractEndDate(String contractEndDate) {
        this.contractEndDate = contractEndDate;
    }

    public String getMoney() {
        return money;
    }

    public void setMoney(String money) {
        this.money = money;
    }

    public String getStatus() {
        return status;
    }

    public void setStatus(String status) {
        this.status = status;
    }

    public String getLatestEndNodeName() {
        return latestEndNodeName;
    }

    public void setLatestEndNodeName(String latestEndNodeName) {
        this.latestEndNodeName = latestEndNodeName;
    }

    public String getFlowType() {
        return flowType;
    }

    public void setFlowType(String flowType) {
        this.flowType = flowType;
    }

    public String getFlowUserName() {
        return flowUserName;
    }

    public void setFlowUserName(String flowUserName) {
        this.flowUserName = flowUserName;
    }

    public String getProductUserName() {
        return productUserName;
    }

    public void setProductUserName(String productUserName) {
        this.productUserName = productUserName;
    }

    public String getSignUserName() {
        return signUserName;
    }

    public void setSignUserName(String signUserName) {
        this.signUserName = signUserName;
    }

    public String getSignTime() {
        return signTime;
    }

    public void setSignTime(String signTime) {
        this.signTime = signTime;
    }

    public String getSignUserOrgName() {
        return signUserOrgName;
    }

    public void setSignUserOrgName(String signUserOrgName) {
        this.signUserOrgName = signUserOrgName;
    }

    public String getDeliveryNum() {
        return deliveryNum;
    }

    public void setDeliveryNum(String deliveryNum) {
        this.deliveryNum = deliveryNum;
    }

    public String getDeliveryStr() {
        return deliveryStr;
    }

    public void setDeliveryStr(String deliveryStr) {
        this.deliveryStr = deliveryStr;
    }

    public String getPublicityNum() {
        return publicityNum;
    }

    public void setPublicityNum(String publicityNum) {
        this.publicityNum = publicityNum;
    }

    public String getPublicityStr() {
        return publicityStr;
    }

    public void setPublicityStr(String publicityStr) {
        this.publicityStr = publicityStr;
    }

    public String getPublicityNo() {
        return publicityNo;
    }

    public void setPublicityNo(String publicityNo) {
        this.publicityNo = publicityNo;
    }

    public String getNoticeNum() {
        return noticeNum;
    }

    public void setNoticeNum(String noticeNum) {
        this.noticeNum = noticeNum;
    }

    public String getNoticeStr() {
        return noticeStr;
    }

    public void setNoticeStr(String noticeStr) {
        this.noticeStr = noticeStr;
    }

    public String getNoticeNo() {
        return noticeNo;
    }

    public void setNoticeNo(String noticeNo) {
        this.noticeNo = noticeNo;
    }

    public String getCertificationStr() {
        return certificationStr;
    }

    public void setCertificationStr(String certificationStr) {
        this.certificationStr = certificationStr;
    }

    public String getEndStr() {
        return endStr;
    }

    public void setEndStr(String endStr) {
        this.endStr = endStr;
    }

    public String getNodeTermTime() {
        return nodeTermTime;
    }

    public void setNodeTermTime(String nodeTermTime) {
        this.nodeTermTime = nodeTermTime;
    }

    public String getPersonalName() {
        return personalName;
    }

    public void setPersonalName(String personalName) {
        this.personalName = personalName;
    }

    public String getNodeStr() {
        return nodeStr;
    }

    public void setNodeStr(String nodeStr) {
        this.nodeStr = nodeStr;
    }

    public String getOrderStr() {
        return orderStr;
    }

    public void setOrderStr(String orderStr) {
        this.orderStr = orderStr;
    }

    public String getContractStr() {
        return contractStr;
    }

    public void setContractStr(String contractStr) {
        this.contractStr = contractStr;
    }

    public String getOverStr() {
        return overStr;
    }

    public void setOverStr(String overStr) {
        this.overStr = overStr;
    }
}
